OpenEdge Data Management:<br />SQL Reference SQLIStatement.makeNULL

Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLIStatement.makeNULL

Sets the value of an SQL statement’s input parameter to NULL. This method is common to the SQLCursor, SQLIStatement, and SQLPStatement classes. This method is redundant with using the setParam method to set an SQL statement’s input parameter to NULL.

Format

public void makeNULL(int f)

Returns

None

Parameters
f
An integer that specifies which input parameter of the SQL statement string to set to NULL. 1 denotes the first input parameter in the statement, 2 denotes the second, n denotes the nth.

Throws

DhSQLException
Example

This code fragment illustrates the makeNULL method:
CREATE PROCEDURE sis_makeNULL()
 
BEGIN
     SQLIStatement insert_sfns1 = new SQLIStatement ("INSERT INTO sfns 
      (fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld) 
      values (?,?,?,?,?,?)" );
     insert_sfns1.setParam(1,new Integer(66));
     insert_sfns1.makeNULL(2);
     insert_sfns1.makeNULL(3);
     insert_sfns1.makeNULL(4);
     insert_sfns1.makeNULL(5);
     insert_sfns1.makeNULL(6);
     insert_sfns1.execute();
END 